package com.zhongwang.mms.gen.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class HOrderDetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public HOrderDetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOdaIdIsNull() {
            addCriterion("oda_id is null");
            return (Criteria) this;
        }

        public Criteria andOdaIdIsNotNull() {
            addCriterion("oda_id is not null");
            return (Criteria) this;
        }

        public Criteria andOdaIdEqualTo(Integer value) {
            addCriterion("oda_id =", value, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdNotEqualTo(Integer value) {
            addCriterion("oda_id <>", value, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdGreaterThan(Integer value) {
            addCriterion("oda_id >", value, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("oda_id >=", value, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdLessThan(Integer value) {
            addCriterion("oda_id <", value, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdLessThanOrEqualTo(Integer value) {
            addCriterion("oda_id <=", value, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdIn(List<Integer> values) {
            addCriterion("oda_id in", values, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdNotIn(List<Integer> values) {
            addCriterion("oda_id not in", values, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdBetween(Integer value1, Integer value2) {
            addCriterion("oda_id between", value1, value2, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaIdNotBetween(Integer value1, Integer value2) {
            addCriterion("oda_id not between", value1, value2, "odaId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdIsNull() {
            addCriterion("oda_odr_id is null");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdIsNotNull() {
            addCriterion("oda_odr_id is not null");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdEqualTo(Integer value) {
            addCriterion("oda_odr_id =", value, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdNotEqualTo(Integer value) {
            addCriterion("oda_odr_id <>", value, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdGreaterThan(Integer value) {
            addCriterion("oda_odr_id >", value, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("oda_odr_id >=", value, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdLessThan(Integer value) {
            addCriterion("oda_odr_id <", value, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdLessThanOrEqualTo(Integer value) {
            addCriterion("oda_odr_id <=", value, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdIn(List<Integer> values) {
            addCriterion("oda_odr_id in", values, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdNotIn(List<Integer> values) {
            addCriterion("oda_odr_id not in", values, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdBetween(Integer value1, Integer value2) {
            addCriterion("oda_odr_id between", value1, value2, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaOdrIdNotBetween(Integer value1, Integer value2) {
            addCriterion("oda_odr_id not between", value1, value2, "odaOdrId");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeIsNull() {
            addCriterion("oda_pro_code is null");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeIsNotNull() {
            addCriterion("oda_pro_code is not null");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeEqualTo(String value) {
            addCriterion("oda_pro_code =", value, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeNotEqualTo(String value) {
            addCriterion("oda_pro_code <>", value, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeGreaterThan(String value) {
            addCriterion("oda_pro_code >", value, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeGreaterThanOrEqualTo(String value) {
            addCriterion("oda_pro_code >=", value, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeLessThan(String value) {
            addCriterion("oda_pro_code <", value, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeLessThanOrEqualTo(String value) {
            addCriterion("oda_pro_code <=", value, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeLike(String value) {
            addCriterion("oda_pro_code like", value, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeNotLike(String value) {
            addCriterion("oda_pro_code not like", value, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeIn(List<String> values) {
            addCriterion("oda_pro_code in", values, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeNotIn(List<String> values) {
            addCriterion("oda_pro_code not in", values, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeBetween(String value1, String value2) {
            addCriterion("oda_pro_code between", value1, value2, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProCodeNotBetween(String value1, String value2) {
            addCriterion("oda_pro_code not between", value1, value2, "odaProCode");
            return (Criteria) this;
        }

        public Criteria andOdaProNameIsNull() {
            addCriterion("oda_pro_name is null");
            return (Criteria) this;
        }

        public Criteria andOdaProNameIsNotNull() {
            addCriterion("oda_pro_name is not null");
            return (Criteria) this;
        }

        public Criteria andOdaProNameEqualTo(String value) {
            addCriterion("oda_pro_name =", value, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameNotEqualTo(String value) {
            addCriterion("oda_pro_name <>", value, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameGreaterThan(String value) {
            addCriterion("oda_pro_name >", value, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameGreaterThanOrEqualTo(String value) {
            addCriterion("oda_pro_name >=", value, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameLessThan(String value) {
            addCriterion("oda_pro_name <", value, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameLessThanOrEqualTo(String value) {
            addCriterion("oda_pro_name <=", value, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameLike(String value) {
            addCriterion("oda_pro_name like", value, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameNotLike(String value) {
            addCriterion("oda_pro_name not like", value, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameIn(List<String> values) {
            addCriterion("oda_pro_name in", values, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameNotIn(List<String> values) {
            addCriterion("oda_pro_name not in", values, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameBetween(String value1, String value2) {
            addCriterion("oda_pro_name between", value1, value2, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaProNameNotBetween(String value1, String value2) {
            addCriterion("oda_pro_name not between", value1, value2, "odaProName");
            return (Criteria) this;
        }

        public Criteria andOdaPartIsNull() {
            addCriterion("oda_part is null");
            return (Criteria) this;
        }

        public Criteria andOdaPartIsNotNull() {
            addCriterion("oda_part is not null");
            return (Criteria) this;
        }

        public Criteria andOdaPartEqualTo(String value) {
            addCriterion("oda_part =", value, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartNotEqualTo(String value) {
            addCriterion("oda_part <>", value, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartGreaterThan(String value) {
            addCriterion("oda_part >", value, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartGreaterThanOrEqualTo(String value) {
            addCriterion("oda_part >=", value, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartLessThan(String value) {
            addCriterion("oda_part <", value, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartLessThanOrEqualTo(String value) {
            addCriterion("oda_part <=", value, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartLike(String value) {
            addCriterion("oda_part like", value, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartNotLike(String value) {
            addCriterion("oda_part not like", value, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartIn(List<String> values) {
            addCriterion("oda_part in", values, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartNotIn(List<String> values) {
            addCriterion("oda_part not in", values, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartBetween(String value1, String value2) {
            addCriterion("oda_part between", value1, value2, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaPartNotBetween(String value1, String value2) {
            addCriterion("oda_part not between", value1, value2, "odaPart");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeIsNull() {
            addCriterion("oda_mat_code is null");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeIsNotNull() {
            addCriterion("oda_mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeEqualTo(String value) {
            addCriterion("oda_mat_code =", value, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeNotEqualTo(String value) {
            addCriterion("oda_mat_code <>", value, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeGreaterThan(String value) {
            addCriterion("oda_mat_code >", value, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("oda_mat_code >=", value, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeLessThan(String value) {
            addCriterion("oda_mat_code <", value, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeLessThanOrEqualTo(String value) {
            addCriterion("oda_mat_code <=", value, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeLike(String value) {
            addCriterion("oda_mat_code like", value, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeNotLike(String value) {
            addCriterion("oda_mat_code not like", value, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeIn(List<String> values) {
            addCriterion("oda_mat_code in", values, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeNotIn(List<String> values) {
            addCriterion("oda_mat_code not in", values, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeBetween(String value1, String value2) {
            addCriterion("oda_mat_code between", value1, value2, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatCodeNotBetween(String value1, String value2) {
            addCriterion("oda_mat_code not between", value1, value2, "odaMatCode");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameIsNull() {
            addCriterion("oda_mat_name is null");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameIsNotNull() {
            addCriterion("oda_mat_name is not null");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameEqualTo(String value) {
            addCriterion("oda_mat_name =", value, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameNotEqualTo(String value) {
            addCriterion("oda_mat_name <>", value, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameGreaterThan(String value) {
            addCriterion("oda_mat_name >", value, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameGreaterThanOrEqualTo(String value) {
            addCriterion("oda_mat_name >=", value, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameLessThan(String value) {
            addCriterion("oda_mat_name <", value, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameLessThanOrEqualTo(String value) {
            addCriterion("oda_mat_name <=", value, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameLike(String value) {
            addCriterion("oda_mat_name like", value, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameNotLike(String value) {
            addCriterion("oda_mat_name not like", value, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameIn(List<String> values) {
            addCriterion("oda_mat_name in", values, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameNotIn(List<String> values) {
            addCriterion("oda_mat_name not in", values, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameBetween(String value1, String value2) {
            addCriterion("oda_mat_name between", value1, value2, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaMatNameNotBetween(String value1, String value2) {
            addCriterion("oda_mat_name not between", value1, value2, "odaMatName");
            return (Criteria) this;
        }

        public Criteria andOdaNumIsNull() {
            addCriterion("oda_num is null");
            return (Criteria) this;
        }

        public Criteria andOdaNumIsNotNull() {
            addCriterion("oda_num is not null");
            return (Criteria) this;
        }

        public Criteria andOdaNumEqualTo(Double value) {
            addCriterion("oda_num =", value, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumNotEqualTo(Double value) {
            addCriterion("oda_num <>", value, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumGreaterThan(Double value) {
            addCriterion("oda_num >", value, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumGreaterThanOrEqualTo(Double value) {
            addCriterion("oda_num >=", value, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumLessThan(Double value) {
            addCriterion("oda_num <", value, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumLessThanOrEqualTo(Double value) {
            addCriterion("oda_num <=", value, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumIn(List<Double> values) {
            addCriterion("oda_num in", values, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumNotIn(List<Double> values) {
            addCriterion("oda_num not in", values, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumBetween(Double value1, Double value2) {
            addCriterion("oda_num between", value1, value2, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaNumNotBetween(Double value1, Double value2) {
            addCriterion("oda_num not between", value1, value2, "odaNum");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdIsNull() {
            addCriterion("oda_whi_id is null");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdIsNotNull() {
            addCriterion("oda_whi_id is not null");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdEqualTo(Integer value) {
            addCriterion("oda_whi_id =", value, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdNotEqualTo(Integer value) {
            addCriterion("oda_whi_id <>", value, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdGreaterThan(Integer value) {
            addCriterion("oda_whi_id >", value, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("oda_whi_id >=", value, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdLessThan(Integer value) {
            addCriterion("oda_whi_id <", value, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdLessThanOrEqualTo(Integer value) {
            addCriterion("oda_whi_id <=", value, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdIn(List<Integer> values) {
            addCriterion("oda_whi_id in", values, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdNotIn(List<Integer> values) {
            addCriterion("oda_whi_id not in", values, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdBetween(Integer value1, Integer value2) {
            addCriterion("oda_whi_id between", value1, value2, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaWhiIdNotBetween(Integer value1, Integer value2) {
            addCriterion("oda_whi_id not between", value1, value2, "odaWhiId");
            return (Criteria) this;
        }

        public Criteria andOdaPriceIsNull() {
            addCriterion("oda_price is null");
            return (Criteria) this;
        }

        public Criteria andOdaPriceIsNotNull() {
            addCriterion("oda_price is not null");
            return (Criteria) this;
        }

        public Criteria andOdaPriceEqualTo(Double value) {
            addCriterion("oda_price =", value, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceNotEqualTo(Double value) {
            addCriterion("oda_price <>", value, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceGreaterThan(Double value) {
            addCriterion("oda_price >", value, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("oda_price >=", value, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceLessThan(Double value) {
            addCriterion("oda_price <", value, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceLessThanOrEqualTo(Double value) {
            addCriterion("oda_price <=", value, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceIn(List<Double> values) {
            addCriterion("oda_price in", values, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceNotIn(List<Double> values) {
            addCriterion("oda_price not in", values, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceBetween(Double value1, Double value2) {
            addCriterion("oda_price between", value1, value2, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaPriceNotBetween(Double value1, Double value2) {
            addCriterion("oda_price not between", value1, value2, "odaPrice");
            return (Criteria) this;
        }

        public Criteria andOdaUnitIsNull() {
            addCriterion("oda_unit is null");
            return (Criteria) this;
        }

        public Criteria andOdaUnitIsNotNull() {
            addCriterion("oda_unit is not null");
            return (Criteria) this;
        }

        public Criteria andOdaUnitEqualTo(String value) {
            addCriterion("oda_unit =", value, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitNotEqualTo(String value) {
            addCriterion("oda_unit <>", value, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitGreaterThan(String value) {
            addCriterion("oda_unit >", value, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitGreaterThanOrEqualTo(String value) {
            addCriterion("oda_unit >=", value, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitLessThan(String value) {
            addCriterion("oda_unit <", value, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitLessThanOrEqualTo(String value) {
            addCriterion("oda_unit <=", value, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitLike(String value) {
            addCriterion("oda_unit like", value, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitNotLike(String value) {
            addCriterion("oda_unit not like", value, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitIn(List<String> values) {
            addCriterion("oda_unit in", values, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitNotIn(List<String> values) {
            addCriterion("oda_unit not in", values, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitBetween(String value1, String value2) {
            addCriterion("oda_unit between", value1, value2, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaUnitNotBetween(String value1, String value2) {
            addCriterion("oda_unit not between", value1, value2, "odaUnit");
            return (Criteria) this;
        }

        public Criteria andOdaBrandIsNull() {
            addCriterion("oda_brand is null");
            return (Criteria) this;
        }

        public Criteria andOdaBrandIsNotNull() {
            addCriterion("oda_brand is not null");
            return (Criteria) this;
        }

        public Criteria andOdaBrandEqualTo(String value) {
            addCriterion("oda_brand =", value, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandNotEqualTo(String value) {
            addCriterion("oda_brand <>", value, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandGreaterThan(String value) {
            addCriterion("oda_brand >", value, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandGreaterThanOrEqualTo(String value) {
            addCriterion("oda_brand >=", value, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandLessThan(String value) {
            addCriterion("oda_brand <", value, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandLessThanOrEqualTo(String value) {
            addCriterion("oda_brand <=", value, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandLike(String value) {
            addCriterion("oda_brand like", value, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandNotLike(String value) {
            addCriterion("oda_brand not like", value, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandIn(List<String> values) {
            addCriterion("oda_brand in", values, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandNotIn(List<String> values) {
            addCriterion("oda_brand not in", values, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandBetween(String value1, String value2) {
            addCriterion("oda_brand between", value1, value2, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaBrandNotBetween(String value1, String value2) {
            addCriterion("oda_brand not between", value1, value2, "odaBrand");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeIsNull() {
            addCriterion("oda_mat_type is null");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeIsNotNull() {
            addCriterion("oda_mat_type is not null");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeEqualTo(Integer value) {
            addCriterion("oda_mat_type =", value, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeNotEqualTo(Integer value) {
            addCriterion("oda_mat_type <>", value, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeGreaterThan(Integer value) {
            addCriterion("oda_mat_type >", value, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("oda_mat_type >=", value, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeLessThan(Integer value) {
            addCriterion("oda_mat_type <", value, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeLessThanOrEqualTo(Integer value) {
            addCriterion("oda_mat_type <=", value, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeIn(List<Integer> values) {
            addCriterion("oda_mat_type in", values, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeNotIn(List<Integer> values) {
            addCriterion("oda_mat_type not in", values, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeBetween(Integer value1, Integer value2) {
            addCriterion("oda_mat_type between", value1, value2, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaMatTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("oda_mat_type not between", value1, value2, "odaMatType");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkIsNull() {
            addCriterion("oda_remark is null");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkIsNotNull() {
            addCriterion("oda_remark is not null");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkEqualTo(String value) {
            addCriterion("oda_remark =", value, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkNotEqualTo(String value) {
            addCriterion("oda_remark <>", value, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkGreaterThan(String value) {
            addCriterion("oda_remark >", value, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("oda_remark >=", value, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkLessThan(String value) {
            addCriterion("oda_remark <", value, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkLessThanOrEqualTo(String value) {
            addCriterion("oda_remark <=", value, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkLike(String value) {
            addCriterion("oda_remark like", value, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkNotLike(String value) {
            addCriterion("oda_remark not like", value, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkIn(List<String> values) {
            addCriterion("oda_remark in", values, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkNotIn(List<String> values) {
            addCriterion("oda_remark not in", values, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkBetween(String value1, String value2) {
            addCriterion("oda_remark between", value1, value2, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaRemarkNotBetween(String value1, String value2) {
            addCriterion("oda_remark not between", value1, value2, "odaRemark");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateIsNull() {
            addCriterion("oda_storage_date is null");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateIsNotNull() {
            addCriterion("oda_storage_date is not null");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateEqualTo(Date value) {
            addCriterion("oda_storage_date =", value, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateNotEqualTo(Date value) {
            addCriterion("oda_storage_date <>", value, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateGreaterThan(Date value) {
            addCriterion("oda_storage_date >", value, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateGreaterThanOrEqualTo(Date value) {
            addCriterion("oda_storage_date >=", value, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateLessThan(Date value) {
            addCriterion("oda_storage_date <", value, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateLessThanOrEqualTo(Date value) {
            addCriterion("oda_storage_date <=", value, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateIn(List<Date> values) {
            addCriterion("oda_storage_date in", values, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateNotIn(List<Date> values) {
            addCriterion("oda_storage_date not in", values, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateBetween(Date value1, Date value2) {
            addCriterion("oda_storage_date between", value1, value2, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaStorageDateNotBetween(Date value1, Date value2) {
            addCriterion("oda_storage_date not between", value1, value2, "odaStorageDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagIsNull() {
            addCriterion("oda_red_flag is null");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagIsNotNull() {
            addCriterion("oda_red_flag is not null");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagEqualTo(Integer value) {
            addCriterion("oda_red_flag =", value, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagNotEqualTo(Integer value) {
            addCriterion("oda_red_flag <>", value, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagGreaterThan(Integer value) {
            addCriterion("oda_red_flag >", value, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("oda_red_flag >=", value, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagLessThan(Integer value) {
            addCriterion("oda_red_flag <", value, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagLessThanOrEqualTo(Integer value) {
            addCriterion("oda_red_flag <=", value, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagIn(List<Integer> values) {
            addCriterion("oda_red_flag in", values, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagNotIn(List<Integer> values) {
            addCriterion("oda_red_flag not in", values, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagBetween(Integer value1, Integer value2) {
            addCriterion("oda_red_flag between", value1, value2, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("oda_red_flag not between", value1, value2, "odaRedFlag");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateIsNull() {
            addCriterion("oda_red_date is null");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateIsNotNull() {
            addCriterion("oda_red_date is not null");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateEqualTo(Date value) {
            addCriterion("oda_red_date =", value, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateNotEqualTo(Date value) {
            addCriterion("oda_red_date <>", value, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateGreaterThan(Date value) {
            addCriterion("oda_red_date >", value, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("oda_red_date >=", value, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateLessThan(Date value) {
            addCriterion("oda_red_date <", value, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateLessThanOrEqualTo(Date value) {
            addCriterion("oda_red_date <=", value, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateIn(List<Date> values) {
            addCriterion("oda_red_date in", values, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateNotIn(List<Date> values) {
            addCriterion("oda_red_date not in", values, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateBetween(Date value1, Date value2) {
            addCriterion("oda_red_date between", value1, value2, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedDateNotBetween(Date value1, Date value2) {
            addCriterion("oda_red_date not between", value1, value2, "odaRedDate");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserIsNull() {
            addCriterion("oda_red_user is null");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserIsNotNull() {
            addCriterion("oda_red_user is not null");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserEqualTo(String value) {
            addCriterion("oda_red_user =", value, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserNotEqualTo(String value) {
            addCriterion("oda_red_user <>", value, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserGreaterThan(String value) {
            addCriterion("oda_red_user >", value, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserGreaterThanOrEqualTo(String value) {
            addCriterion("oda_red_user >=", value, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserLessThan(String value) {
            addCriterion("oda_red_user <", value, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserLessThanOrEqualTo(String value) {
            addCriterion("oda_red_user <=", value, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserLike(String value) {
            addCriterion("oda_red_user like", value, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserNotLike(String value) {
            addCriterion("oda_red_user not like", value, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserIn(List<String> values) {
            addCriterion("oda_red_user in", values, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserNotIn(List<String> values) {
            addCriterion("oda_red_user not in", values, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserBetween(String value1, String value2) {
            addCriterion("oda_red_user between", value1, value2, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaRedUserNotBetween(String value1, String value2) {
            addCriterion("oda_red_user not between", value1, value2, "odaRedUser");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeIsNull() {
            addCriterion("oda_drawing_code is null");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeIsNotNull() {
            addCriterion("oda_drawing_code is not null");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeEqualTo(String value) {
            addCriterion("oda_drawing_code =", value, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeNotEqualTo(String value) {
            addCriterion("oda_drawing_code <>", value, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeGreaterThan(String value) {
            addCriterion("oda_drawing_code >", value, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeGreaterThanOrEqualTo(String value) {
            addCriterion("oda_drawing_code >=", value, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeLessThan(String value) {
            addCriterion("oda_drawing_code <", value, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeLessThanOrEqualTo(String value) {
            addCriterion("oda_drawing_code <=", value, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeLike(String value) {
            addCriterion("oda_drawing_code like", value, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeNotLike(String value) {
            addCriterion("oda_drawing_code not like", value, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeIn(List<String> values) {
            addCriterion("oda_drawing_code in", values, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeNotIn(List<String> values) {
            addCriterion("oda_drawing_code not in", values, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeBetween(String value1, String value2) {
            addCriterion("oda_drawing_code between", value1, value2, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaDrawingCodeNotBetween(String value1, String value2) {
            addCriterion("oda_drawing_code not between", value1, value2, "odaDrawingCode");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusIsNull() {
            addCriterion("oda_making_pieces_status is null");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusIsNotNull() {
            addCriterion("oda_making_pieces_status is not null");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusEqualTo(String value) {
            addCriterion("oda_making_pieces_status =", value, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusNotEqualTo(String value) {
            addCriterion("oda_making_pieces_status <>", value, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusGreaterThan(String value) {
            addCriterion("oda_making_pieces_status >", value, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusGreaterThanOrEqualTo(String value) {
            addCriterion("oda_making_pieces_status >=", value, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusLessThan(String value) {
            addCriterion("oda_making_pieces_status <", value, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusLessThanOrEqualTo(String value) {
            addCriterion("oda_making_pieces_status <=", value, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusLike(String value) {
            addCriterion("oda_making_pieces_status like", value, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusNotLike(String value) {
            addCriterion("oda_making_pieces_status not like", value, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusIn(List<String> values) {
            addCriterion("oda_making_pieces_status in", values, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusNotIn(List<String> values) {
            addCriterion("oda_making_pieces_status not in", values, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusBetween(String value1, String value2) {
            addCriterion("oda_making_pieces_status between", value1, value2, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaMakingPiecesStatusNotBetween(String value1, String value2) {
            addCriterion("oda_making_pieces_status not between", value1, value2, "odaMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductIsNull() {
            addCriterion("oda_if_finished_product is null");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductIsNotNull() {
            addCriterion("oda_if_finished_product is not null");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductEqualTo(Integer value) {
            addCriterion("oda_if_finished_product =", value, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductNotEqualTo(Integer value) {
            addCriterion("oda_if_finished_product <>", value, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductGreaterThan(Integer value) {
            addCriterion("oda_if_finished_product >", value, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductGreaterThanOrEqualTo(Integer value) {
            addCriterion("oda_if_finished_product >=", value, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductLessThan(Integer value) {
            addCriterion("oda_if_finished_product <", value, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductLessThanOrEqualTo(Integer value) {
            addCriterion("oda_if_finished_product <=", value, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductIn(List<Integer> values) {
            addCriterion("oda_if_finished_product in", values, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductNotIn(List<Integer> values) {
            addCriterion("oda_if_finished_product not in", values, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductBetween(Integer value1, Integer value2) {
            addCriterion("oda_if_finished_product between", value1, value2, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaIfFinishedProductNotBetween(Integer value1, Integer value2) {
            addCriterion("oda_if_finished_product not between", value1, value2, "odaIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andOdaAmountIsNull() {
            addCriterion("oda_amount is null");
            return (Criteria) this;
        }

        public Criteria andOdaAmountIsNotNull() {
            addCriterion("oda_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOdaAmountEqualTo(Double value) {
            addCriterion("oda_amount =", value, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountNotEqualTo(Double value) {
            addCriterion("oda_amount <>", value, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountGreaterThan(Double value) {
            addCriterion("oda_amount >", value, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountGreaterThanOrEqualTo(Double value) {
            addCriterion("oda_amount >=", value, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountLessThan(Double value) {
            addCriterion("oda_amount <", value, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountLessThanOrEqualTo(Double value) {
            addCriterion("oda_amount <=", value, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountIn(List<Double> values) {
            addCriterion("oda_amount in", values, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountNotIn(List<Double> values) {
            addCriterion("oda_amount not in", values, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountBetween(Double value1, Double value2) {
            addCriterion("oda_amount between", value1, value2, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaAmountNotBetween(Double value1, Double value2) {
            addCriterion("oda_amount not between", value1, value2, "odaAmount");
            return (Criteria) this;
        }

        public Criteria andOdaPositionIsNull() {
            addCriterion("oda_position is null");
            return (Criteria) this;
        }

        public Criteria andOdaPositionIsNotNull() {
            addCriterion("oda_position is not null");
            return (Criteria) this;
        }

        public Criteria andOdaPositionEqualTo(String value) {
            addCriterion("oda_position =", value, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionNotEqualTo(String value) {
            addCriterion("oda_position <>", value, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionGreaterThan(String value) {
            addCriterion("oda_position >", value, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionGreaterThanOrEqualTo(String value) {
            addCriterion("oda_position >=", value, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionLessThan(String value) {
            addCriterion("oda_position <", value, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionLessThanOrEqualTo(String value) {
            addCriterion("oda_position <=", value, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionLike(String value) {
            addCriterion("oda_position like", value, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionNotLike(String value) {
            addCriterion("oda_position not like", value, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionIn(List<String> values) {
            addCriterion("oda_position in", values, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionNotIn(List<String> values) {
            addCriterion("oda_position not in", values, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionBetween(String value1, String value2) {
            addCriterion("oda_position between", value1, value2, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaPositionNotBetween(String value1, String value2) {
            addCriterion("oda_position not between", value1, value2, "odaPosition");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeIsNull() {
            addCriterion("oda_track_code is null");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeIsNotNull() {
            addCriterion("oda_track_code is not null");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeEqualTo(String value) {
            addCriterion("oda_track_code =", value, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeNotEqualTo(String value) {
            addCriterion("oda_track_code <>", value, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeGreaterThan(String value) {
            addCriterion("oda_track_code >", value, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeGreaterThanOrEqualTo(String value) {
            addCriterion("oda_track_code >=", value, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeLessThan(String value) {
            addCriterion("oda_track_code <", value, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeLessThanOrEqualTo(String value) {
            addCriterion("oda_track_code <=", value, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeLike(String value) {
            addCriterion("oda_track_code like", value, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeNotLike(String value) {
            addCriterion("oda_track_code not like", value, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeIn(List<String> values) {
            addCriterion("oda_track_code in", values, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeNotIn(List<String> values) {
            addCriterion("oda_track_code not in", values, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeBetween(String value1, String value2) {
            addCriterion("oda_track_code between", value1, value2, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaTrackCodeNotBetween(String value1, String value2) {
            addCriterion("oda_track_code not between", value1, value2, "odaTrackCode");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoIsNull() {
            addCriterion("oda_case_no is null");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoIsNotNull() {
            addCriterion("oda_case_no is not null");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoEqualTo(String value) {
            addCriterion("oda_case_no =", value, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoNotEqualTo(String value) {
            addCriterion("oda_case_no <>", value, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoGreaterThan(String value) {
            addCriterion("oda_case_no >", value, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoGreaterThanOrEqualTo(String value) {
            addCriterion("oda_case_no >=", value, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoLessThan(String value) {
            addCriterion("oda_case_no <", value, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoLessThanOrEqualTo(String value) {
            addCriterion("oda_case_no <=", value, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoLike(String value) {
            addCriterion("oda_case_no like", value, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoNotLike(String value) {
            addCriterion("oda_case_no not like", value, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoIn(List<String> values) {
            addCriterion("oda_case_no in", values, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoNotIn(List<String> values) {
            addCriterion("oda_case_no not in", values, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoBetween(String value1, String value2) {
            addCriterion("oda_case_no between", value1, value2, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaCaseNoNotBetween(String value1, String value2) {
            addCriterion("oda_case_no not between", value1, value2, "odaCaseNo");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateIsNull() {
            addCriterion("oda_boxing_date is null");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateIsNotNull() {
            addCriterion("oda_boxing_date is not null");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateEqualTo(Date value) {
            addCriterion("oda_boxing_date =", value, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateNotEqualTo(Date value) {
            addCriterion("oda_boxing_date <>", value, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateGreaterThan(Date value) {
            addCriterion("oda_boxing_date >", value, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateGreaterThanOrEqualTo(Date value) {
            addCriterion("oda_boxing_date >=", value, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateLessThan(Date value) {
            addCriterion("oda_boxing_date <", value, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateLessThanOrEqualTo(Date value) {
            addCriterion("oda_boxing_date <=", value, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateIn(List<Date> values) {
            addCriterion("oda_boxing_date in", values, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateNotIn(List<Date> values) {
            addCriterion("oda_boxing_date not in", values, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateBetween(Date value1, Date value2) {
            addCriterion("oda_boxing_date between", value1, value2, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaBoxingDateNotBetween(Date value1, Date value2) {
            addCriterion("oda_boxing_date not between", value1, value2, "odaBoxingDate");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeIsNull() {
            addCriterion("oda_stock_type is null");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeIsNotNull() {
            addCriterion("oda_stock_type is not null");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeEqualTo(Integer value) {
            addCriterion("oda_stock_type =", value, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeNotEqualTo(Integer value) {
            addCriterion("oda_stock_type <>", value, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeGreaterThan(Integer value) {
            addCriterion("oda_stock_type >", value, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("oda_stock_type >=", value, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeLessThan(Integer value) {
            addCriterion("oda_stock_type <", value, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeLessThanOrEqualTo(Integer value) {
            addCriterion("oda_stock_type <=", value, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeIn(List<Integer> values) {
            addCriterion("oda_stock_type in", values, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeNotIn(List<Integer> values) {
            addCriterion("oda_stock_type not in", values, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeBetween(Integer value1, Integer value2) {
            addCriterion("oda_stock_type between", value1, value2, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaStockTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("oda_stock_type not between", value1, value2, "odaStockType");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeIsNull() {
            addCriterion("oda_sap_code is null");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeIsNotNull() {
            addCriterion("oda_sap_code is not null");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeEqualTo(String value) {
            addCriterion("oda_sap_code =", value, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeNotEqualTo(String value) {
            addCriterion("oda_sap_code <>", value, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeGreaterThan(String value) {
            addCriterion("oda_sap_code >", value, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeGreaterThanOrEqualTo(String value) {
            addCriterion("oda_sap_code >=", value, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeLessThan(String value) {
            addCriterion("oda_sap_code <", value, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeLessThanOrEqualTo(String value) {
            addCriterion("oda_sap_code <=", value, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeLike(String value) {
            addCriterion("oda_sap_code like", value, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeNotLike(String value) {
            addCriterion("oda_sap_code not like", value, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeIn(List<String> values) {
            addCriterion("oda_sap_code in", values, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeNotIn(List<String> values) {
            addCriterion("oda_sap_code not in", values, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeBetween(String value1, String value2) {
            addCriterion("oda_sap_code between", value1, value2, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaSapCodeNotBetween(String value1, String value2) {
            addCriterion("oda_sap_code not between", value1, value2, "odaSapCode");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdIsNull() {
            addCriterion("oda_out_ity_id is null");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdIsNotNull() {
            addCriterion("oda_out_ity_id is not null");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdEqualTo(Integer value) {
            addCriterion("oda_out_ity_id =", value, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdNotEqualTo(Integer value) {
            addCriterion("oda_out_ity_id <>", value, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdGreaterThan(Integer value) {
            addCriterion("oda_out_ity_id >", value, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("oda_out_ity_id >=", value, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdLessThan(Integer value) {
            addCriterion("oda_out_ity_id <", value, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdLessThanOrEqualTo(Integer value) {
            addCriterion("oda_out_ity_id <=", value, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdIn(List<Integer> values) {
            addCriterion("oda_out_ity_id in", values, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdNotIn(List<Integer> values) {
            addCriterion("oda_out_ity_id not in", values, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdBetween(Integer value1, Integer value2) {
            addCriterion("oda_out_ity_id between", value1, value2, "odaOutItyId");
            return (Criteria) this;
        }

        public Criteria andOdaOutItyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("oda_out_ity_id not between", value1, value2, "odaOutItyId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}